Save the edited Unicode text file in Excel

When you complete editing an exported Unicode text file in Excel, save the file in Excel.

To save the edited Unicode text file in Excel

  1. In Excel, from the File menu, select Save As.
  2. Make sure that Unicode Text (*.txt) is selected in the Save as type box and click Save.
  3. When the message appears stating that the file may contain features that are not compatible with Unicode Text and asking if you want to keep the workbook in this format, click Yes. This saves the file but does not close it.
  4. Close the file in Excel. When asked whether you want to save the changes, click Save. You can then save the file using its original name or specify a new name.
  5. When prompted with the same message described in Step 3, click Yes.

    Tip:

    • If a Unicode text file has been opened and saved in Excel, and you open the file in Notepad, the double quotes surrounding the string definitions will have been removed for most strings.
    • String definitions containing embedded double quotes or other characters that Excel treats as special characters (such as commas) will be enclosed within double quotes. Any embedded double quotes will have been converted to a pair of double quotes. The FactoryTalk View String Import Export Wizard imports all of these correctly.

See also

Export text strings to an Excel spreadsheet

Edit an exported Unicode text file in Excel

Edit an exported Unicode text file in Notepad

Import text strings from a Unicode text file